﻿
CREATE VIEW vw_LogEvent_Detailed
AS
SELECT A.LogEventRowId, B.DeploymentId, A.RoleRowId, B.RoleName, InstanceNumber, DateTimeUTC, EventNumber, EventLevel, EventLevelName, [Message]
FROM LogEvent A
	LEFT OUTER Join [Role] B
		On A.RoleRowId = B.RoleRowId
	LEFT OUTER Join EventLevel C
		On A.EventLevel = C.EventLevelId